SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 302;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('302', 'Cash Crusaders Malvern','Nisuar Investments','Cash Crusaders Malvern','Shop L0-17 Malvern Park, Shopping Centre, CNR Ridley Park and Main Road','TBA','TBA','2023/942603/07','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Malvern',CompanyName = 'Nisuar Investments', TradingAs = 'Cash Crusaders Malvern', Address='Shop L0-17 Malvern Park, Shopping Centre, CNR Ridley Park and Main Road', ContactNo = 'TBA', VATRegNo = 'TBA',RegNo = '2023/942603/07', StoreEmailAddress = 'TBA' where Store_ID = 302;
 END


 SET IDENTITY_INSERT [dbo].[store] off